package com.ruoyi.shop.member.mapper;

import java.math.BigDecimal;
import java.util.List;
import com.ruoyi.shop.member.domain.ShopMemberPoint;

/**
 * 会员积分Mapper接口
 * 
 * @author xuxiang
 */
public interface ShopMemberPointMapper {
	/**
	 * 查询会员积分
	 * 
	 * @param pointId 根据主键查询
	 * @return 会员积分
	 */
	public ShopMemberPoint selectPointById(Long pointId);

	/**
	 * 查询会员积分
	 * 
	 * @param memberId 根据会员Id查询
	 * @return 会员积分
	 */
	public ShopMemberPoint selectPointByMemberId(Long memberId);

	/**
	 * 查询会员积分列表
	 * 
	 * @param shopMemberPoint 会员积分
	 * @return 会员积分集合
	 */
	public List<ShopMemberPoint> selectPointList(ShopMemberPoint shopMemberPoint);

	/**
	 * 新增会员积分
	 * 
	 * @param shopMemberPoint 会员积分
	 * @return 结果
	 */
	public int insertPoint(ShopMemberPoint shopMemberPoint);

	/**
	 * 修改会员积分
	 * 
	 * @param shopMemberPoint 会员积分
	 * @return 结果
	 */
	public int updatePoint(ShopMemberPoint shopMemberPoint);

	/**
	 * 积分统计
	 * 
	 * @param shopMemberPoint
	 * @return
	 */
	public BigDecimal sumPoint(ShopMemberPoint shopMemberPoint);

}
